IF exists(SELECT * FROM dbo.sysobjects WHERE name='deHistoriek' AND xtype='V') 
BEGIN
	DROP VIEW deHistoriek
END
GO

create view deHistoriek
as
select * from studiegegevens..historiek